UML dialect for designing object-relational databases
نویسندگان
چکیده
The market trends indicate that the next generation database technology will be dominated by object-relational systems. This shift to the new technology calls for visual modeling techniques to facilitate the design of object-relational database systems. Even though Unified Modeling Language (UML) is not currently equiped to manage this task, it can be extended for it.The paper defines design constructs needed for the development of an object-relational database system. The constructs include those that assist in the migration process from a relational to an object-relational database. Both data and procedural constructs are considered. Many UML extensions in the proposed UML dialect are derived by stereotyping existing UML elements. New classes are created to model object-relational constructs, and they are assigned their own distinct icons. Any special constraints on relationships between concepts in the extended UML are explained through practical examples. The mappings from design models to an object-relational implementation are exemplified.
منابع مشابه
Regular paper AMethodologicalApproach forObject-RelationalDatabase Design usingUML
Themost common way of designing databases is by means of a conceptual model, such as E/R, without taking into account other views of the system. New object-oriented design languages, such as UML (Unified Modelling Language), allow the whole system, including the database schema, to be modelled in a uniform way. Moreover, as UML is an extendable language, it allows for any necessary introduction...
متن کاملAggregation and Composition in Object - Relational Database Design
Recently, there have emerged more sophisticated applications, which have to represent complex objects related with complex relationships, such as aggregations and compositions. New object-relational databases are more appropriated than relational databases to support complex objects. Besides, the most common way of designing databases is using the E/R model, without taking in account the progra...
متن کاملDatabase Design with Uml: Implementation Issues
The paper examines the benefits and drawbacks of the object-relational database technology using UML diagrams in comparison with the entity-relationship approach. Guidelines for transition to UML are presented and mapping strategy to relational and object-relational schema is overviewed. OR database extensions are outlined and two of the most popular object oriented modelling tools Oracle Desig...
متن کاملO Object-relational Modeling in the Uml
Modeling techniques play an important role in the development of database applications. One of the trends in current database management systems is that they become object-relational (Stonebraker & Brown, 1999). The most recent version of the SQL standard, SQL:1999, includes object-relational features, and a number of leading companies have already released packages that incorporate them. Well-...
متن کاملMapping Conceptual Models to Database Schemas
The mapping of a conceptual-model instance to a database schema is fundamentally the same for all conceptual models. A conceptual-model instance describes the relationships and constraints among the various data items. Given the relationships and constraints, the mappings group data items together into flat relational schemas for relational databases and into nested relational schemas for objec...
متن کامل